﻿CREATE PROCEDURE [dbo].[GetPictureByID]
	@ID varchar(50)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
IF EXISTS (SELECT SmallUrl as pictureURL, pictureid, PictureDesc, createDate from AW_Picture where PropertyId = @ID)
BEGIN
  SELECT SmallUrl as pictureURL, pictureid, PictureDesc, createDate from AW_Picture where PropertyId = @ID;
END

	
END
